To filter a range by cell fill color, follow these steps:

1.Define the sort and filter range.

2.Click the sort and filter button in the upper cell of the column where you want to filter the data.

3.In the window that opens, select By color filtering method. Filtering by color is available if the range has filled cells.

4.In the palette of colors available for filtering, select a fill color.

5.Click Apply.

 

The appearance of the sort and filter button may differ from the one shown here because it depends on whether sorting has been previously applied, the sort order (ascending or descending), and whether a filter has been previously applied:

–: No sorting or filtering applied.

–: Filter applied, no sorting applied.

–: Sorted in ascending order with no filter applied.

–: Sorted in descending order with no filter applied.

–: Sorted in ascending order with filter applied.

–: Sorted in descending order with filter applied.

 

To clear the filter applied to a column by fill color without resetting the sorting, follow this steps:

1.Click  Sort and filter.

2.In the window that opens, select By value filtering method.

3.Click Apply.

 

To clear the filter applied to the column by fill color along with the sorting:

1.Click  Sort and filter.

2.In the window that appears, click Clear.